clear all
set more off

local path0="C:\Dropbox\GeneticsProject (1)\REStat\round_accepted_replication_files\"

*~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

cd  "`path0'data\direct_genes"

import excel "A118G_final.xlsx", cellrange(A1) sheet("A118G") firstrow clear

cd "`path0'workfiles"
compress
save updated_A118G, replace

*~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

cd  "`path0'data\direct_genes"

import excel "5-HTTLPR_final.xlsx", cellrange(A1) sheet("chiao commentary data") firstrow clear

cd "`path0'workfiles"
compress
rename HTTLPR freq_5HTTLPR
save updated_5HTTLPR, replace

